DROP TABLE IF EXISTS jms_ods.yl_oms_interceptorrecord;
CREATE EXTERNAL TABLE jms_ods.yl_oms_interceptorrecord (
WAYBILL_NO        string        comment     '运单编号'   ,         --NVARCHAR2(20)
INTERCEPTOR_PIECE_ID        bigint        comment     '拦截件id'   ,         --NUMBER(20)
INTERCEPT_NETWORK_ID        bigint        comment     '拦截网点id'   ,         --NUMBER(20)
INTERCEPT_NETWORK_NAME        string        comment     '拦截网点名称'   ,         --NVARCHAR2(30)
INTERCEPT_NETWORK_CODE        string        comment     '拦截网点编码'   ,         --NVARCHAR2(20)
INTERCEPT_ID        bigint        comment     '拦截人ID'   ,         --NUMBER(20)
INTERCEPT_NAME        string        comment     '拦截人名称'   ,         --NVARCHAR2(60)
INTERCEPT_CODE        string        comment     '拦截人编码'   ,         --NVARCHAR2(20)
INTERCEPT_TIME        timestamp        comment     '拦截时间'   ,         --DATE
SCAN_TIME        timestamp        comment     '扫描时间'       ,     --DATE
operation_source        string        comment     '扫描时间'            --NVARCHAR2(160)
)
      COMMENT '拦截件扫描表'
    PARTITIONED BY (dt STRING COMMENT '更新/创建日期 (yyyy-MM-dd)')
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_ods.db/external/yl_oms_interceptorrecord'
    TBLPROPERTIES (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );

MSCK REPAIR TABLE jms_ods.yl_oms_interceptorrecord;
